3 visuals for webpage

This code will help produce the three visuals that are going to be a part of each equity tracker indicator webpage: regional map (tract level) of most recent data, chart of the most recent data, chart of trends over time.

If the indicator is available through a tract-level data set. Getting the data to a workable version may require some data transformation. To explore, clean, transform, and generate a final data set, please use the data-gen-tract-template. This script will generate an .rda for the map and an .rda for the charts. These data sets will be loaded in before the data visualization code.

Indicator Explanation

Traffic related deaths and serious injuries per 100,000 by census tract. Understanding where traffic related deaths and serious injuries occur at a higher rate can help us understand which communities are disproportionately impacted.

1. Map of most recent data

To map data in this form, there should be a value corresponding to each census tract. Depending on the year or source of the data, this could be about 700 rows for data at the 2010 census tract resolution, or about 900 rows for data at the 2020 census tract resolution.

The map scale has been adjusted to the natural log of the rate to make the map colors meaningful.

Create Visual

Sources: Washington Traffic Safety Commission; U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles


Data call outs

  1. 42: The region’s average rate for traffic related deaths and serious injuries per 100,000 per census tract in 2021
  2. 1146: highest rate for a census tract in 2021
  3. 348: number of census tracts with a rate of zero in 2021


Insights & Analysis

  • The census tracts with the highest death and serious injury rate are the census tracts in Pierce County that includes the Port of Tacoma and the Tacoma Dome (1146) and the downtown Tacoma census tract next to the Tacoma Dome (602) and in King County the tracts in northwest Auburn that includes the Auburn airport and part of HWY 167 (912) and the tract that includes Lumen Field and T-Mobile Park (737)
  • There are 348 census tracts with a death and serious injury rate of zero in the region. For Kitsap County, 27% of census tracts (16) have a rate of zero, followed by Pierce with 30% (58), Snohomish with 41% (71), and King county 41% (203)
  • Pierce County has the highest death and serious injury rate (54), followed by Kitsap (47), King (39), and Snohomish (36)



2. Facet of most recent data

Create Visual

Traffic Related Deaths and Serious Injuries per 100,000

Census Tract Level

Washington Traffic Safety Commission U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)

Data call outs

As a region:

  1. 2.75x: Communities with high concentrations of households with lower income are 2.75 times more likely to have a collision with a death or serious injury occur in their community

  2. 2.25x: Communities with high concentrations of people with a disability are 2.25 times more likely to have these collisions

  3. 1.5x: Communities with high concentrations of households with limited English proficiency are 1.5 times more likely to have these collisions

Insights & Analysis

  • As a region, communities with high concentrations of households with lower income or people with a disability are most disproportionately impacted by traffic related deaths and serious injuries
  • The counties with the largest gap between low and high concentrations of households with lower income are King and Pierce counties
  • The counties with the largest gap between low and high concentrations of people with a disability are King and Pierce counties
  • The counties with the largest gap between low and high concentrations of people of color are King and Pierce counties
  • The counties with the largest gap between low and medium high/high concentrations of households with limited English proficiency are Kitsap and Pierce counties


3. Facet of trend data

Create Visual

Traffic Related Deaths and Serious Injuries per 100,000

Census Tract Level

Washington Traffic Safety Commission U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)

Data call outs

As a region:

  1. 1.5x: In 2016, communities with low and high concentrations of households with limited English proficiency had nearly the same rate of collisions with a death or serious injury but by 2021 - the gap had increased by 1.5 times

  2. 50%: The gap increased 50% between communities with low and high concentrations of people with a disability between 2012 and 2021

  3. 25% larger gap: The gap increased 25% between communities with low and high concentrations of households with lower income between 2010 and 2021


Insights & Analysis

  • Households with lower income and people with disabilities have been disproportionately impacted by traffic related deaths and serious injuries consistently from 2010 to 2021
  • Pierce County has the largest gap increase between the communities with low and high concentrations of people of color and households with lower income between 2010 and 2021
  • King and Pierce counties have the largest gap increase between communities with low and high concentrations of people with disabilities between 2016 and 2021



Transfer files

Copy files from Github > Y drive

Copy files from Y drive > website folder

Back to top of the page